Navicat provides a number of powerful tools for working with the databases.
The following tools are available:
Import Wizard
Imports data from TXT, CSV, XML, DBF, MS Excel and ODBC.
Export Wizard
Exports data to TXT, CSV, DBF, XML and MS Excel.
Data Transfer
Transfers tables/views/procedures/functions/sequences/events between databases/schemas or plain text file.
Data Synchronization
Synchronizes data in different databases/schemas to be kept up-to-date so that each
repository contains the same information.
Structure Synchronization
Compares the structure of two similar databases/schemas and produces a set of alter
statements in MySQL, Oracle, PostgreSQL and SQL Server.
Backup/Restore
Allows you to backup/restore your databases/schemas for MySQL, PostgreSQL and SQLite.
Batch Job/Schedule
Allows you to schedule a batch job which being executed at a specified time and support e-mail notification service.
Console
Provides interactive text-based screen for user query input and result output from MySQL, Oracle, PostgreSQL, SQLite and SQL Server.
Dump SQL File
Dumps database/schema/table(s) to SQL file.
Execute SQL File
Executes SQL file.
Convert to SQLite 3
Converts a SQLite 2 file into a SQLite 3 file.
Print Structure
Prints database/schema/table structure.
Log Files
Keeps track on the actions (e.g. SQL statements being executed) have been
performed in Navicat.